% tar -zxvf psqlodbc-xx.xx.xxxx.tar.gz % cd psqlodbc-xx.xx.xxxx % ./configure % make % make install
A PostgreSQL ODBC driver needed to make the ODBC connection to Teiid is not bundled with the Teiid distribution. The appropriate driver needs be downloaded directly from the PostgreSQL web site. We have tested with 8.04.200 version of the ODBC driver.
Download the ODBC driver from PostgreSQL download site. If you are looking for 64-bit Windows driver download the driver from here.
Extract the contents of the ZIP file into a temporary location on your system. For example: "c:\temp\pgodbc"
Double click on "psqlodbc.msi" file or (.exe file in the case of 64 bit) to start installation of the driver.
The Wizard appears as
Click "Next".
The next step of the wizard displays.
Carefully read it, and check the "I accept the terms in the License Agreement", if you are agreeing to the licensing terms. Then click "Next".
The next step of the wizard displays.
If you want to install in a different directory than the default that is already selected, click the "Browse" button and select a directory. Click "Next" to start installing in the selected directory.
The next step of the wizard displays.
This step summarizes the choices you have made in the wizard. Review this information. If you need to change anything, you can use the Back button to return to previous steps. Click "Install" to proceed.
1.The installation wizard copies the necessary files to the location you specified. When it finishes, the following screen displays.
Click "Finish" to complete.
For all other platforms other than Microsoft Windows, the ODBC driver needs built from the source files provided. Download the ODBC driver source files from the PostgreSQL download site. Untar the files to a temporary location. For example: "~/tmp/pgodbc". Build and install the driver by running the commands below.
You should use super user account or use "sudo" command for running the "make install" command.
% tar -zxvf psqlodbc-xx.xx.xxxx.tar.gz % cd psqlodbc-xx.xx.xxxx % ./configure % make % make install
Some *nix distributions may already provide binary forms of the appropriate driver, which can be used as an alternative to building from source.